Query Data

This activity retrieves rows of data from a database and makes the data available as tokens.

Note: This activity produces a token for each column in the specified table. The tokens for the first row the query finds are available to other activities in the workflow. If you want to access tokens for additional rows, use a For Each Row activity.

How does this activity look in the Designer Pane?

To add this activity to a workflow definition 

• Drag it from the Toolbox Pane and drop it in the Designer Pane.

To configure this activity

• Select the activity in the Designer Pane to configure the following property boxes in the Properties Pane.
• Activity Name
• Activity Description
• Data Source
• Query Criteria
• Rows to Return